github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/manual_testing/many controls/queries/q18.sql (about)

     1  select
     2      -- Required Columns
     3      'arn:' || partition || ':apigateway:' || region || '::/apis/' || rest_api_id || '/stages/' || name as resource,
     4      case
     5          when method_settings -> '*/*' ->> 'CachingEnabled' = 'true'
     6              and method_settings -> '*/*' ->> 'CacheDataEncrypted' = 'true' then 'ok'
     7          else 'alarm'
     8          end as status,
     9      case
    10          when method_settings -> '*/*' ->> 'CachingEnabled' = 'true'
    11              and method_settings -> '*/*' ->> 'CacheDataEncrypted' = 'true'
    12              then title || ' API cache and encryption enabled.'
    13          else title || ' API cache and encryption not enabled.'
    14          end as reason,
    15      -- Additional Dimensions
    16      region,
    17      account_id
    18  from
    19      aws_api_gateway_stage;